package com.atguigu.realtime.gmallpublisher.mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

public interface OrderMapper {
    // 计算总的销售额
    BigDecimal getOrderAmount(String date);

    List<Map<String, Object>> getHourOrderAmount(String date);


}
/*
┌─create_hour─┬─total_amount─┐
│ 03          │    341512.00 │
│ 01          │    391006.00 │
│ 07          │    764666.00 │
└─────────────┴──────────────┘



select create_hour, sum(final_total_amount) total_amount
from order_wide
where create_date='2020-12-11'
group by create_hour;
 */